﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using DoAn.DTO;

namespace DoAn.DAO
{
    public class VungMienDAO
    {
        public static DataTable loadVung()
        {
            string sql = "Select * from VUNGMIEN";
            DataTable dt = new DataTable();
            dt = DataProvider.DataTable(sql);
            return dt;
        }
        public static string layTenVung(VungMienDTO vm)
        {
            string sql = "Select * from VungMien where MaVung=" + vm.MaVung.ToString();
            DataTable dt = new DataTable();
            dt = DataProvider.DataTable(sql);
           return dt.Rows[0]["TenVung"].ToString();
        }
    }
}